package com.generator.demo.dao;

import com.generator.demo.dao.BpSparepartCheckMain;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.apache.ibatis.type.JdbcType;

public interface BpSparepartCheckMainMapper {
    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table BP_SPAREPART_CHECK_MAIN
     *
     * @mbg.generated Tue Nov 30 18:16:24 CST 2021
     */
    @Delete({
        "delete from BP_SPAREPART_CHECK_MAIN",
        "where ID = #{id,jdbcType=NUMERIC}"
    })
    int deleteByPrimaryKey(Long id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table BP_SPAREPART_CHECK_MAIN
     *
     * @mbg.generated Tue Nov 30 18:16:24 CST 2021
     */
    @Insert({
        "insert into BP_SPAREPART_CHECK_MAIN (ID, SHEET_ID, ",
        "TITLE, CITY, COUNTY, ",
        "INS_PROC_ID, MODEL_KIND, ",
        "SPECIALTY, SUB_SPECIALTY, ",
        "SEND_TIME, SEND_USERID, ",
        "SEND_DEPTID, SEND_ROLEID, ",
        "SEND_PHONE, MANAGER_ID, ",
        "CABINET_ID, CABINET_CODE, ",
        "CABINET_NAME, WAREHOUSE_ID, ",
        "WAREHOUSE_CODE, WAREHOUSE_NAME, ",
        "END_USERID, END_ROLEID, ",
        "END_DEPTID, END_TIME, ",
        "END_STATISFIED, END_OPINION, ",
        "STATUS, REQ_INFO, ",
        "SEND_YEAR, SEND_MONTH, ",
        "SEND_DAY, CANCEL_USER_ID, ",
        "CANCEL_DATE, CANCLE_REASON, ",
        "IS_DELETED, NOTES)",
        "values (#{id,jdbcType=NUMERIC}, #{sheetId,jdbcType=VARCHAR}, ",
        "#{title,jdbcType=VARCHAR}, #{city,jdbcType=VARCHAR}, #{county,jdbcType=VARCHAR}, ",
        "#{insProcId,jdbcType=NUMERIC}, #{modelKind,jdbcType=VARCHAR}, ",
        "#{specialty,jdbcType=VARCHAR}, #{subSpecialty,jdbcType=VARCHAR}, ",
        "#{sendTime,jdbcType=TIMESTAMP}, #{sendUserid,jdbcType=VARCHAR}, ",
        "#{sendDeptid,jdbcType=VARCHAR}, #{sendRoleid,jdbcType=VARCHAR}, ",
        "#{sendPhone,jdbcType=VARCHAR}, #{managerId,jdbcType=VARCHAR}, ",
        "#{cabinetId,jdbcType=NUMERIC}, #{cabinetCode,jdbcType=VARCHAR}, ",
        "#{cabinetName,jdbcType=VARCHAR}, #{warehouseId,jdbcType=NUMERIC}, ",
        "#{warehouseCode,jdbcType=VARCHAR}, #{warehouseName,jdbcType=VARCHAR}, ",
        "#{endUserid,jdbcType=VARCHAR}, #{endRoleid,jdbcType=VARCHAR}, ",
        "#{endDeptid,jdbcType=VARCHAR}, #{endTime,jdbcType=TIMESTAMP}, ",
        "#{endStatisfied,jdbcType=NUMERIC}, #{endOpinion,jdbcType=VARCHAR}, ",
        "#{status,jdbcType=NUMERIC}, #{reqInfo,jdbcType=VARCHAR}, ",
        "#{sendYear,jdbcType=NUMERIC}, #{sendMonth,jdbcType=NUMERIC}, ",
        "#{sendDay,jdbcType=NUMERIC}, #{cancelUserId,jdbcType=VARCHAR}, ",
        "#{cancelDate,jdbcType=TIMESTAMP}, #{cancleReason,jdbcType=VARCHAR}, ",
        "#{isDeleted,jdbcType=NUMERIC}, #{notes,jdbcType=VARCHAR})"
    })
    int insert(BpSparepartCheckMain record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table BP_SPAREPART_CHECK_MAIN
     *
     * @mbg.generated Tue Nov 30 18:16:24 CST 2021
     */
    @Select({
        "select",
        "ID, SHEET_ID, TITLE, CITY, COUNTY, INS_PROC_ID, MODEL_KIND, SPECIALTY, SUB_SPECIALTY, ",
        "SEND_TIME, SEND_USERID, SEND_DEPTID, SEND_ROLEID, SEND_PHONE, MANAGER_ID, CABINET_ID, ",
        "CABINET_CODE, CABINET_NAME, WAREHOUSE_ID, WAREHOUSE_CODE, WAREHOUSE_NAME, END_USERID, ",
        "END_ROLEID, END_DEPTID, END_TIME, END_STATISFIED, END_OPINION, STATUS, REQ_INFO, ",
        "SEND_YEAR, SEND_MONTH, SEND_DAY, CANCEL_USER_ID, CANCEL_DATE, CANCLE_REASON, ",
        "IS_DELETED, NOTES",
        "from BP_SPAREPART_CHECK_MAIN",
        "where ID = #{id,jdbcType=NUMERIC}"
    })
    @Results({
        @Result(column="ID", property="id", jdbcType=JdbcType.NUMERIC, id=true),
        @Result(column="SHEET_ID", property="sheetId", jdbcType=JdbcType.VARCHAR),
        @Result(column="TITLE", property="title", jdbcType=JdbcType.VARCHAR),
        @Result(column="CITY", property="city", jdbcType=JdbcType.VARCHAR),
        @Result(column="COUNTY", property="county", jdbcType=JdbcType.VARCHAR),
        @Result(column="INS_PROC_ID", property="insProcId", jdbcType=JdbcType.NUMERIC),
        @Result(column="MODEL_KIND", property="modelKind", jdbcType=JdbcType.VARCHAR),
        @Result(column="SPECIALTY", property="specialty", jdbcType=JdbcType.VARCHAR),
        @Result(column="SUB_SPECIALTY", property="subSpecialty", jdbcType=JdbcType.VARCHAR),
        @Result(column="SEND_TIME", property="sendTime", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="SEND_USERID", property="sendUserid", jdbcType=JdbcType.VARCHAR),
        @Result(column="SEND_DEPTID", property="sendDeptid", jdbcType=JdbcType.VARCHAR),
        @Result(column="SEND_ROLEID", property="sendRoleid", jdbcType=JdbcType.VARCHAR),
        @Result(column="SEND_PHONE", property="sendPhone", jdbcType=JdbcType.VARCHAR),
        @Result(column="MANAGER_ID", property="managerId", jdbcType=JdbcType.VARCHAR),
        @Result(column="CABINET_ID", property="cabinetId", jdbcType=JdbcType.NUMERIC),
        @Result(column="CABINET_CODE", property="cabinetCode", jdbcType=JdbcType.VARCHAR),
        @Result(column="CABINET_NAME", property="cabinetName", jdbcType=JdbcType.VARCHAR),
        @Result(column="WAREHOUSE_ID", property="warehouseId", jdbcType=JdbcType.NUMERIC),
        @Result(column="WAREHOUSE_CODE", property="warehouseCode", jdbcType=JdbcType.VARCHAR),
        @Result(column="WAREHOUSE_NAME", property="warehouseName", jdbcType=JdbcType.VARCHAR),
        @Result(column="END_USERID", property="endUserid", jdbcType=JdbcType.VARCHAR),
        @Result(column="END_ROLEID", property="endRoleid", jdbcType=JdbcType.VARCHAR),
        @Result(column="END_DEPTID", property="endDeptid", jdbcType=JdbcType.VARCHAR),
        @Result(column="END_TIME", property="endTime", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="END_STATISFIED", property="endStatisfied", jdbcType=JdbcType.NUMERIC),
        @Result(column="END_OPINION", property="endOpinion", jdbcType=JdbcType.VARCHAR),
        @Result(column="STATUS", property="status", jdbcType=JdbcType.NUMERIC),
        @Result(column="REQ_INFO", property="reqInfo", jdbcType=JdbcType.VARCHAR),
        @Result(column="SEND_YEAR", property="sendYear", jdbcType=JdbcType.NUMERIC),
        @Result(column="SEND_MONTH", property="sendMonth", jdbcType=JdbcType.NUMERIC),
        @Result(column="SEND_DAY", property="sendDay", jdbcType=JdbcType.NUMERIC),
        @Result(column="CANCEL_USER_ID", property="cancelUserId", jdbcType=JdbcType.VARCHAR),
        @Result(column="CANCEL_DATE", property="cancelDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="CANCLE_REASON", property="cancleReason", jdbcType=JdbcType.VARCHAR),
        @Result(column="IS_DELETED", property="isDeleted", jdbcType=JdbcType.NUMERIC),
        @Result(column="NOTES", property="notes", jdbcType=JdbcType.VARCHAR)
    })
    BpSparepartCheckMain selectByPrimaryKey(Long id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table BP_SPAREPART_CHECK_MAIN
     *
     * @mbg.generated Tue Nov 30 18:16:24 CST 2021
     */
    @Select({
        "select",
        "ID, SHEET_ID, TITLE, CITY, COUNTY, INS_PROC_ID, MODEL_KIND, SPECIALTY, SUB_SPECIALTY, ",
        "SEND_TIME, SEND_USERID, SEND_DEPTID, SEND_ROLEID, SEND_PHONE, MANAGER_ID, CABINET_ID, ",
        "CABINET_CODE, CABINET_NAME, WAREHOUSE_ID, WAREHOUSE_CODE, WAREHOUSE_NAME, END_USERID, ",
        "END_ROLEID, END_DEPTID, END_TIME, END_STATISFIED, END_OPINION, STATUS, REQ_INFO, ",
        "SEND_YEAR, SEND_MONTH, SEND_DAY, CANCEL_USER_ID, CANCEL_DATE, CANCLE_REASON, ",
        "IS_DELETED, NOTES",
        "from BP_SPAREPART_CHECK_MAIN"
    })
    @Results({
        @Result(column="ID", property="id", jdbcType=JdbcType.NUMERIC, id=true),
        @Result(column="SHEET_ID", property="sheetId", jdbcType=JdbcType.VARCHAR),
        @Result(column="TITLE", property="title", jdbcType=JdbcType.VARCHAR),
        @Result(column="CITY", property="city", jdbcType=JdbcType.VARCHAR),
        @Result(column="COUNTY", property="county", jdbcType=JdbcType.VARCHAR),
        @Result(column="INS_PROC_ID", property="insProcId", jdbcType=JdbcType.NUMERIC),
        @Result(column="MODEL_KIND", property="modelKind", jdbcType=JdbcType.VARCHAR),
        @Result(column="SPECIALTY", property="specialty", jdbcType=JdbcType.VARCHAR),
        @Result(column="SUB_SPECIALTY", property="subSpecialty", jdbcType=JdbcType.VARCHAR),
        @Result(column="SEND_TIME", property="sendTime", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="SEND_USERID", property="sendUserid", jdbcType=JdbcType.VARCHAR),
        @Result(column="SEND_DEPTID", property="sendDeptid", jdbcType=JdbcType.VARCHAR),
        @Result(column="SEND_ROLEID", property="sendRoleid", jdbcType=JdbcType.VARCHAR),
        @Result(column="SEND_PHONE", property="sendPhone", jdbcType=JdbcType.VARCHAR),
        @Result(column="MANAGER_ID", property="managerId", jdbcType=JdbcType.VARCHAR),
        @Result(column="CABINET_ID", property="cabinetId", jdbcType=JdbcType.NUMERIC),
        @Result(column="CABINET_CODE", property="cabinetCode", jdbcType=JdbcType.VARCHAR),
        @Result(column="CABINET_NAME", property="cabinetName", jdbcType=JdbcType.VARCHAR),
        @Result(column="WAREHOUSE_ID", property="warehouseId", jdbcType=JdbcType.NUMERIC),
        @Result(column="WAREHOUSE_CODE", property="warehouseCode", jdbcType=JdbcType.VARCHAR),
        @Result(column="WAREHOUSE_NAME", property="warehouseName", jdbcType=JdbcType.VARCHAR),
        @Result(column="END_USERID", property="endUserid", jdbcType=JdbcType.VARCHAR),
        @Result(column="END_ROLEID", property="endRoleid", jdbcType=JdbcType.VARCHAR),
        @Result(column="END_DEPTID", property="endDeptid", jdbcType=JdbcType.VARCHAR),
        @Result(column="END_TIME", property="endTime", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="END_STATISFIED", property="endStatisfied", jdbcType=JdbcType.NUMERIC),
        @Result(column="END_OPINION", property="endOpinion", jdbcType=JdbcType.VARCHAR),
        @Result(column="STATUS", property="status", jdbcType=JdbcType.NUMERIC),
        @Result(column="REQ_INFO", property="reqInfo", jdbcType=JdbcType.VARCHAR),
        @Result(column="SEND_YEAR", property="sendYear", jdbcType=JdbcType.NUMERIC),
        @Result(column="SEND_MONTH", property="sendMonth", jdbcType=JdbcType.NUMERIC),
        @Result(column="SEND_DAY", property="sendDay", jdbcType=JdbcType.NUMERIC),
        @Result(column="CANCEL_USER_ID", property="cancelUserId", jdbcType=JdbcType.VARCHAR),
        @Result(column="CANCEL_DATE", property="cancelDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="CANCLE_REASON", property="cancleReason", jdbcType=JdbcType.VARCHAR),
        @Result(column="IS_DELETED", property="isDeleted", jdbcType=JdbcType.NUMERIC),
        @Result(column="NOTES", property="notes", jdbcType=JdbcType.VARCHAR)
    })
    List<BpSparepartCheckMain> selectAll();

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table BP_SPAREPART_CHECK_MAIN
     *
     * @mbg.generated Tue Nov 30 18:16:24 CST 2021
     */
    @Update({
        "update BP_SPAREPART_CHECK_MAIN",
        "set SHEET_ID = #{sheetId,jdbcType=VARCHAR},",
          "TITLE = #{title,jdbcType=VARCHAR},",
          "CITY = #{city,jdbcType=VARCHAR},",
          "COUNTY = #{county,jdbcType=VARCHAR},",
          "INS_PROC_ID = #{insProcId,jdbcType=NUMERIC},",
          "MODEL_KIND = #{modelKind,jdbcType=VARCHAR},",
          "SPECIALTY = #{specialty,jdbcType=VARCHAR},",
          "SUB_SPECIALTY = #{subSpecialty,jdbcType=VARCHAR},",
          "SEND_TIME = #{sendTime,jdbcType=TIMESTAMP},",
          "SEND_USERID = #{sendUserid,jdbcType=VARCHAR},",
          "SEND_DEPTID = #{sendDeptid,jdbcType=VARCHAR},",
          "SEND_ROLEID = #{sendRoleid,jdbcType=VARCHAR},",
          "SEND_PHONE = #{sendPhone,jdbcType=VARCHAR},",
          "MANAGER_ID = #{managerId,jdbcType=VARCHAR},",
          "CABINET_ID = #{cabinetId,jdbcType=NUMERIC},",
          "CABINET_CODE = #{cabinetCode,jdbcType=VARCHAR},",
          "CABINET_NAME = #{cabinetName,jdbcType=VARCHAR},",
          "WAREHOUSE_ID = #{warehouseId,jdbcType=NUMERIC},",
          "WAREHOUSE_CODE = #{warehouseCode,jdbcType=VARCHAR},",
          "WAREHOUSE_NAME = #{warehouseName,jdbcType=VARCHAR},",
          "END_USERID = #{endUserid,jdbcType=VARCHAR},",
          "END_ROLEID = #{endRoleid,jdbcType=VARCHAR},",
          "END_DEPTID = #{endDeptid,jdbcType=VARCHAR},",
          "END_TIME = #{endTime,jdbcType=TIMESTAMP},",
          "END_STATISFIED = #{endStatisfied,jdbcType=NUMERIC},",
          "END_OPINION = #{endOpinion,jdbcType=VARCHAR},",
          "STATUS = #{status,jdbcType=NUMERIC},",
          "REQ_INFO = #{reqInfo,jdbcType=VARCHAR},",
          "SEND_YEAR = #{sendYear,jdbcType=NUMERIC},",
          "SEND_MONTH = #{sendMonth,jdbcType=NUMERIC},",
          "SEND_DAY = #{sendDay,jdbcType=NUMERIC},",
          "CANCEL_USER_ID = #{cancelUserId,jdbcType=VARCHAR},",
          "CANCEL_DATE = #{cancelDate,jdbcType=TIMESTAMP},",
          "CANCLE_REASON = #{cancleReason,jdbcType=VARCHAR},",
          "IS_DELETED = #{isDeleted,jdbcType=NUMERIC},",
          "NOTES = #{notes,jdbcType=VARCHAR}",
        "where ID = #{id,jdbcType=NUMERIC}"
    })
    int updateByPrimaryKey(BpSparepartCheckMain record);
}